SELECT   T."ID", T."ORETYPE", T."X", T."Y", T."Z", T."PROFILE", T."BOREHOLE", T."MINING", T."DEPTH", T."LENGTH", T."CORE", T."CORE_PERCENT", T."Pb", T."Pbf", T."Zn", T."Znf", T."BaSO4", T."Cu", T."Pb_03", T."Zn_06", T."BaSO4_6", T."Metall_Zn", T."Metall_Ba", T."DENSITY", T."SAMPLE", T."VARIANTS_Zn", T."VARIANTS_Ba", T."VARIANT3_Zn", T."VARIANT2_Zn", T."VARIANT1_Zn", T."VARIANT1_Ba", T."VARIANT2_Ba", T."VARIANT3_Ba"
FROM "D:\GEOBLOCK\DATA\BASE\DHOLE\DZ2_52.db" T
WHERE T."PROFILE"="52" and T."LENGTH"<>0 and T."ORETYPE"<>0
ORDER BY T."ORETYPE"
